-
Re: COUNTIFS & VALUE FUNCTION not providing OUTPUT
Hello @NCNWIncData Try: =IF([Deliverables Count]@row=9, COUNTIFS([Deliverables Count]:[Deliverables Count],9),"")1 · -
Re: Forumla To Sum up Goods in and Out from a seperate Sheet
Hello @WWARRIOR2018 Try this: Goods In Column: =SUMIFS({QTY},{Movement Type},"Goods In") Goods Out Column: =SUMIFS({QTY},{Movement Type},"Goods Out")1 · -
Re: Mutiple Project Status
Hello @Enoch Mak I'd recommend having the table of list of project statuses and duration thresholds on a different sheet. Then try this formula on your Project Status Health column: =IF([Duration (Su…1 · -
Re: Conditional Formatting on Multiple Sheets
Hello @Lisa McMunn Try this: Create a helper column (for example checkbox "Training Done" column) on your Associate Information Sheet Add this formula: =IF(HAS({Badge # Column in Training T…1 · -
Re: Percent column adds two zeros
Hello @noshiro Format first your % complete column to percentage. Then add your calculations. For example: =[Column 1]@row / [Column 2]@row If you're manually adding data on the % complete column, no…1 ·